package com.bosssoft.boss_exam_db.mapper;

import com.bosssoft.boss_exam_db.baseMapper.MyMapper;
import com.bosssoft.boss_exam_db.entity.Exam;
import com.bosssoft.boss_exam_db.model.vo.*;
import org.apache.ibatis.annotations.Param;

import java.util.List;
// 考试Mapper
public interface ExamMapper extends MyMapper<Exam> {
    // 根据考试ID查看考试和试卷
    List<ExamExamPaperVO> getExamAndPaperById(String examId);
    // 根据考试ID查询考试分数
    List<ApplicantTotalScoreVO> queryExamScoreByExamId(@Param("examCode") String examCode);
    // 根据考试ID查询考试应聘人根据题型的分数占比
    List<QuestiontypeScoreVO> queryQuestionTypeScore(@Param("examId") String examId, @Param("applicantId") String applicantId);
    // 根据考核ID查询考试应聘人根据题型的分数占比
    List<QuestionSubjectScoreVO> queryQuestionSubjectScore(@Param("examId") String examId, @Param("applicantId") String applicantId);
    // 根据考试ID查询考试根据题型的的分数占比
    List<QuestiontypeTotalScoreVO> queryTotalScoreByQuestionType(@Param("examId") String examId);
    // 根据考试ID查询考试根据科目的分数占比
    List<SubjectTotalScoreVO>  queryTotalScoreBySubject(@Param("examId") String examId);
}